Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | |
CustomerAccountID (FK) | A unique identifier for a customer account. | ID_CTAC | Identity | integer | CustomerAccount(LE_CTAC) |
CustomerAccountCardID (FK) | A 16 digit Credit or Debit card PAN as defined by ISO-7812, uniquely identifying CustomerAccountCard. | AI_ACNT_CT_CRD | CreditDebitCardPAN | varchar(20) | CustomerAccountCard(LE_ACNT_CT_CRD) |
AmountReceived | The monetary payment on account received from the Customer | MO_PYM_AGT_RCV | Money | decimal(16,5) | |
CustomerAccountInvoiceID (FK) | A unique system assigned identifier for the CustomerAccountInvoice | ID_INVC_CTAC | Identity | integer | CustomerAccountInvoice(DO_INVC_CTAC) |
BalanceDue | The monetary amount due on the CustomerAccount after the payment is processed - as calculated by the POS Application and printed on the transaction receipt. This is a transaction snapshot of the balance plus accured interest in CustomerAccount which is the on-going balance. | MO_BLNC | MoneyShortRetail | decimal(7,2) | |
RefundFlag | A boolean flag that is set to YES means this PaymentOnAccountLineItem represents a REFUND which reduces the accounts receivable balance of a customer. See POSLOG6 PaymentOnAccountBase complex type @Refund | FL_RFD | Code4 | char(4) | |
PaymentOnAccountTypeCode | Designates the type of payment and target account it is intended to debit or credit (depending on the transaction context). Valid values are: REVOLVING_CHG_PAYMENT LAYAWAY_PAYMENT INSTALLMENT_PAYMENT | CD_PYM_ON_ACNT_TYP | Code | varchar(20) | |